package com.haoyanbing.easyexcel;

import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.converters.date.DateNumberConverter;
import lombok.Data;
import java.util.Date;

/**
 * 模板数据
 * @author haoyanbing
 * @since 2020/4/8
 */
@Data
@ExcelIgnoreUnannotated
public class TemplateData {


    /**
     * 主键ID
     */

    /**
     * 开始日期
     */

    @ExcelProperty(value = "开始日期",converter = DateNumberConverter.class,index = 0)
    private Date  startDate;

    /**
     * 结束日期
     */
    @ExcelProperty(value = "结束日期",converter = DateConverter.class,index = 1)
    private Date endDate;

    /**
     * 广告组合名称
     */
    @ExcelProperty(value = "广告组合名称", index = 2)
    private String combinationName;


    /**
     * 货币
     */
    @ExcelProperty(value = "货币", index = 3)
    private String currency;

    /**
     * 广告活动名称
     */
    @ExcelProperty(value = "广告活动名称", index = 4)
    private String adActivityName;

    /**
     * 广告组名称
     */
    @ExcelProperty(value = "广告组名称", index = 5)
    private String adGroupName;

    /**
     * 广告SKU
     */
    @ExcelProperty(value = "广告SKU", index = 6)
    private String adSku;

    /**
     * 广告ASIN
     */
    @ExcelProperty(value = "广告ASIN", index = 7)
    private String adAsin;


    /**
     * 展示量
     */
    @ExcelProperty(value = "展示量", index = 8)
    private String impressions;

    /**
     * 点击量
     */
    @ExcelProperty(value = "点击量", index = 9)
    private String clicks;


    /**
     * 点击率
     */
    @ExcelProperty(value = "点击率", index = 10)
    private String ctr;


    /**
     * 每次点击成本
     */
    @ExcelProperty(value = "每次点击成本", index = 11)
    private String cpc;


    /**
     * 花费
     */
    @ExcelProperty(value = "花费", index = 12)
    private String cost;


    /**
     * 7天总销售额
     */
    @ExcelProperty(value = "7天总销售额", index = 13)
    private String totalVolumes;

    /**
     * 广告成本销售比（ACOS）
     */
    @ExcelProperty(value = "广告成本销售比（ACOS）", index = 14)
    private String acos;

    /**
     * 投入产出比(RoAS)
     */
    @ExcelProperty(value = "投入产出比(RoAS)", index = 15)
    private String roac;

    /**
     * 7天总订单数
     */
    @ExcelProperty(value = "7天总订单数", index = 16)
    private String totalOrders;


    /**
     * 7天总销售量
     */
    @ExcelProperty(value = "7天总销售量", index = 17)
    private String totalSales;

    /**
     * 7天转化率
     */
    @ExcelProperty(value = "7天转化率", index = 18)
    private String conversionRate;

    /**
     * 7天内广告SKU销售量
     */
    @ExcelProperty(value = "7天内广告SKU销售量", index = 19)
    private String skuSalesVolume;

    /**
     * 7天内其他SKU销售量
     */
    @ExcelProperty(value = "7天内其他SKU销售量", index = 20)
    private String otherSalesVolume;


    /**
     * 7天内广告SKU销售额
     */
    @ExcelProperty(value = "7天内广告SKU销售额", index = 21)
    private String adSkuSales;

    /**
     * 7天内其他SKU销售额
     */
    @ExcelProperty(value = "7天内其他SKU销售额", index = 22)
    private String adOtherSales;


    private String cpo;


    private String spc;


}
